-- @owner: @chen
-- @date: 2025-11-21
-- @testpoint: D库原生on commit option 无法与ON/ TEXTIMAGE_ON 并存，合理报错
@conn PrimaryDbDmode;
--D库原生on commit option 无法与ON/ TEXTIMAGE_ON 并存
--ERROR: syntax error at or near
create table t1_commit_on_case004(a int) on commit on "default";
create table t2_commit_on_case004(a int) on commit on [primary22];
create table t3_commit_on_case004(a int) on commit on (primary22);
create table t4_commit_on_case004(a int) on commit on {primary22};
create table t5_commit_on_case004(a int) on commit on 'primary22';
create table t6_commit_on_case004(a int) on commit on $primary22$;
create table t7_commit_on_case004(a int) on commit on <primary22>;
create table t8_commit_on_case004(a int) on commit on primary22;
create table t9_commit_on_case004(a int) on commit on begin;
create table t10_commit_on_case004(a int) on commit on [end];

create table t1_commit_textimage_on_case004(a int) on commit TEXTIMAGE_ON "default";
create table t2_commit_textimage_on_case004(a int) on commit TEXTIMAGE_ON [primary22];
create table t3_commit_textimage_on_case004(a int) on commit TEXTIMAGE_ON (primary22);
create table t4_commit_textimage_on_case004(a int) on commit TEXTIMAGE_ON {primary22};
create table t5_commit_textimage_on_case004(a int) on commit TEXTIMAGE_ON 'primary22';
create table t6_commit_textimage_on_case004(a int) on commit TEXTIMAGE_ON $primary22$;
create table t7_commit_textimage_on_case004(a int) on commit TEXTIMAGE_ON <primary22>;
create table t8_commit_textimage_on_case004(a int) on commit TEXTIMAGE_ON primary22;
create table t9_commit_textimage_on_case004(a int) on commit TEXTIMAGE_ON begin;
create table t10_commit_textimage_on_case004(a int) on commit TEXTIMAGE_ON [end];

create table t1_commit_delete_textimage_on_case004(a int) on commit delete rows TEXTIMAGE_ON "default";
create table t2_commit_delete_textimage_on_case004(a int) on commit delete rows TEXTIMAGE_ON [primary22];
create table t3_commit_delete_textimage_on_case004(a int) on commit delete rows TEXTIMAGE_ON (primary22);
create table t4_commit_delete_textimage_on_case004(a int) on commit delete rows TEXTIMAGE_ON {primary22};
create table t5_commit_delete_textimage_on_case004(a int) on commit delete rows TEXTIMAGE_ON 'primary22';
create table t6_commit_delete_textimage_on_case004(a int) on commit delete rows TEXTIMAGE_ON $primary22$;
create table t7_commit_delete_textimage_on_case004(a int) on commit delete rows TEXTIMAGE_ON <primary22>;
create table t8_commit_delete_textimage_on_case004(a int) on commit delete rows TEXTIMAGE_ON primary22;
create table t9_commit_delete_textimage_on_case004(a int) on commit delete rows TEXTIMAGE_ON begin;
create table t10_commit_delete_textimage_on_case004(a int) on commit delete rows TEXTIMAGE_ON [end];


create table t1_commit_delete_on_case004(a int) on commit delete rows ON "default";
create table t2_commit_delete_on_case004(a int) on commit delete rows ON [primary22];
create table t3_commit_delete_on_case004(a int) on commit delete rows ON (primary22);
create table t4_commit_delete_on_case004(a int) on commit delete rows ON {primary22};
create table t5_commit_delete_on_case004(a int) on commit delete rows ON 'primary22';
create table t6_commit_delete_on_case004(a int) on commit delete rows ON $primary22$;
create table t7_commit_delete_on_case004(a int) on commit delete rows ON <primary22>;
create table t8_commit_delete_on_case004(a int) on commit delete rows ON primary22;
create table t9_commit_delete_on_case004(a int) on commit delete rows ON begin;


create table t_commit_on_textimage_on_case004(a int) on commit delete rows on "default" textimage_on "default";
create table t_commit_textimage_on_on_case004(a int) on commit delete rows TEXTIMAGE_ON [end] on "default";
create table t_commit_on_on_case004(a int) on commit delete rows on "default" on "default";
create table t_commit_textimage_on_textimage_on_case004(a int) on commit delete rows TEXTIMAGE_ON "default" TEXTIMAGE_ON "default";

--drop table
drop table if exists t1_commit_textimage_on_case004;
drop table if exists t2_commit_textimage_on_case004;
drop table if exists t5_commit_textimage_on_case004;
drop table if exists t8_commit_textimage_on_case004;
drop table if exists t9_commit_textimage_on_case004;
drop table if exists t10_commit_textimage_on_case004;